UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9B2oay2sMDO4KyPRguIo48reYS3XCkZT15iO2UWcFLA='
WHERE
key_id = 'd2929f47639f730a85337748b75913e60cef5ea244cc35bbb2c58ece037a5a0f'
AND (
token = '9B2oay2sMDO4KyPRguIo48reYS3XCkZT15iO2UWcFLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)