SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1ad8dc54fc6e546d1d224fc4ce7645ed7e3de50c08c24db402e897c46581a2a8' 
  AND token = 'KAHscNAdVUCNZjAqjyKZzifOi9q62WQAVWr0uq/vIgY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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