SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f0c86a10d7a5eadb4c09d63c997c25f18477b7bd1880b5601f5e2776b832cdcf' 
  AND token = 'OgCMbmv9vl5cpnDph0LFjo184JWMIQ3aY3L6P3LwZ9s=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

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