SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f0020a95da1f208553976280ab015a12eb0645d48fc4183c1b02b4e0baea1916' 
  AND token = 'JktidXHl70sxevG2XndW948u256VNrNVI7j3YZ6xn6o=' 
  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"
    }
  }
}