SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '92f0c1699bd16430ba76cfd0c162890edaf044027b840ef82f55e8e99b0fb830' 
  AND token = 'QR6dlStkjjsqlS48xl+99XVwyjDUuduflwEdh6juAB0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}