SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0e81014deb7bad27f5f44ea9e1c35c2fbddfda68f6679a34e310bdc00e6f3236' 
  AND token = 'KuGHFJ8ifw08scRPb76oE4Vox5E2khoQx3BpglgXbYI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

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