SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ed3f2e3a968f02c5e12580149e497f1229f81527c156236a1aab207e6050a9da' 
  AND token = 'bH5eo0+PAS2+91Kc67Os0gy+Js02jERdpfHuHARdCK8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00048

JSON explain

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