UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8Irq0RPXd/gzB5V9wYmZfa1oGPqrfXLS2cxxyOiDbcU=' 
WHERE 
  key_id = 'caf5d2db3b59b9c6155ae719b6936fcce79322681883db859c1a486bf979c6e2' 
  AND (
    token = '8Irq0RPXd/gzB5V9wYmZfa1oGPqrfXLS2cxxyOiDbcU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019