UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XW/4Reakj/C39wlMR4dTpT+01MiEvO1ZQ3/Kd9GZzvc=' 
WHERE 
  key_id = '54c8b23fcddee6c33949503bf45ea9f489c120b80cb1729c1f7c60dc396e9e5b' 
  AND (
    token = 'XW/4Reakj/C39wlMR4dTpT+01MiEvO1ZQ3/Kd9GZzvc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023