UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GszDxwHt7UeMjJ/LNg+MfIPdREKWnts58D9jqCjtXw4='
WHERE
key_id = '789dac627695b3dbf4d58f77582b70cb57146cf03a09721d3a1902fc35b1ebfb'
AND (
token = 'GszDxwHt7UeMjJ/LNg+MfIPdREKWnts58D9jqCjtXw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)