SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1c21c04ab427d189abccbdc17d28be03ae5e9e9ffccd9d27ea6378f7a0fb7e0f' 
  AND token = 'T1aFV0cPuB4LPSJ0Jd8tn030E7TOasLGBv6ACXZKhDc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}