UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '34EwHhcbm07+yeI3kUyZ1PYYK76GTsFPPY7r+5/96sI='
WHERE
key_id = '20586ec6e419b965cb5844e7d169cc73c4abd73c54acb57acba4d549c2cec634'
AND (
token = '34EwHhcbm07+yeI3kUyZ1PYYK76GTsFPPY7r+5/96sI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)