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