SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bee4ef4aae9d7b60da9dd8026866b757ef506e23ffe9614795bf8ce7bc2e268e' 
  AND token = 'l7kaK3oWtqSx+lWlsj5Psu23RYrWh+OUKMuGC8v3o68=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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