UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oCcnsk7zQiwkVXxF+MVTmCOmrstgEuL8sKIwfpEEWzU=' 
WHERE 
  key_id = '609c574823b7c3a6af6bdab85c19d81b9d35bde2eb6a9cb6a300ff4569000b55' 
  AND (
    token = 'oCcnsk7zQiwkVXxF+MVTmCOmrstgEuL8sKIwfpEEWzU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027