SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '79799503010186c21ce76ff09f80578184effce5bb86e4ee6f233cd2953b02b0' 
  AND token = 'h0TXT4gYOp/3eY8woKqbgfsNj6Wn0nosOnkLOn75jr8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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