UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Io9cSxZuhzE7N7aL3h5Eia5wyedjrOCOdIhmf4XTXaQ=' 
WHERE 
  key_id = '362d8b24e0393b5c485fb2e3e41a40baca0973fb03365cf635a7d52745452f2a' 
  AND (
    token = 'Io9cSxZuhzE7N7aL3h5Eia5wyedjrOCOdIhmf4XTXaQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025