SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1580e0a0d4e1097c264c6a6af79214348c7444cdba6c2e4048f9d9c04e0c604f' 
  AND token = '0Y0VWWhFmQGlKWS3sLI3N8K7k8aQAR4gBEVOqHGUIak=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00049

JSON explain

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