SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '71dd46fc6771c6d3d18b6e9505d41b7a380a7beea3a3a11bcf4b9e4eda4bfca5' 
  AND token = 'EuSsMFB+rxBABjZQWFWsCN6BdkKFAicfciHzptRYJYE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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