SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '35eb9f42302b6a9eb5e1c6b4995151603ce3c1ba26d503a3e60c183b2595bb4b' 
  AND token = 'Z/oTw77mbvqLkUuc9cOFt0NCWp3dR5CZ35rWl7cNL6U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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