SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '005dde6040d6ca9db3518488ea59f1bfffcab4d11707f8cd79a23167fba8576e' 
  AND token = 'Qx6YoVVILCSgKj9+bHdv9xQhhpAj6s46cnUd/shIGOo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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