SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd741cb7065ee4b127f6b8eb757ae14aa6e1c50af047e067d7a6b349fb25c3c6c' 
  AND token = 'hVZpOJalY+3vclITfwv67Af90JRCgdsWEKyugs/8NQE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

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