SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '64d1a3a404e5c6c906a41d621f6a19356185353e2c4f5e6cc9c4f06d14a5ec42' 
  AND token = 'JMtdqogJ7pLzMFGqWCm9pd20Tg2cOR+bkpjBSuudv5M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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