SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '829c8c877dcad865fd504b4b0c6c1439940f9862c17c714f12ccf4e304c5c2bf' 
  AND token = 'ydM7ZL/qyxEFOZdEwd1X9cPHtejqHI4Kedluhl14OfY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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