SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8af1b5be43ebc081d02b2b59bd5674456b7ef1661137d2deb571334fb773a962' 
  AND token = '2z0xtmT55dRlS5b7fkhkBTnNIxm0Gfg8wrpV4tn1OSQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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