UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2SfBZLrCh5By640aq+OlXCRNfjjpz3YCfnaoAMCO8jQ='
WHERE
key_id = 'c1bffa3ec02017e169a953637038d50d5e3b7aae765f0c028a8d8b18e5b1af98'
AND (
token = '2SfBZLrCh5By640aq+OlXCRNfjjpz3YCfnaoAMCO8jQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)