SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '28a1e5d691a76f11275cec7f09b3837391e5b2e14a96c7fd111f64ca4eda41ab' 
  AND token = 'azz+I64EdYcrqHOo4BKy3d64evIbnLLp2NBtLQ/V+uI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}