SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bbe0796ab63f4e2b74ad82d7c1d6f9ae4ecf8aead68519886b5c07a888f56265' 
  AND token = 'dVYqRjdYY1G1C9t+x4eoI2qMG49RykXC8GQ9hbcSExQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

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