SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0fda9ecef2160669a34fbebfc2e17d2b71ce63f8ab36801fa63709e0e2a75062' 
  AND token = 'UpJTPVW6oICf4ZXTc4GgWoY9Mfj/VnWxOzdht6/9GHQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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