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