UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'glzW8vYraOgvwhIWIJqtQvaZrtkAzn4eXs2uIrY7ztU=' 
WHERE 
  key_id = 'f1c30f55a5c0bb857dcea6a5a68a457c7c0d680f597f4bd36becb8db8a049e1b' 
  AND (
    token = 'glzW8vYraOgvwhIWIJqtQvaZrtkAzn4eXs2uIrY7ztU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040