SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1f20527d892db4b54823bd8fd55028ec1135b52c07699dffa0e4169e19416791' 
  AND token = 'W+flZMu5Gk9qt7jBcmXRHNh3F71/TVE0P14FuoHQmvg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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