UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tTwV/JSg1NN0JNQTFlWMfPja0V9lENl1deKcoCmgYHY='
WHERE
key_id = 'c248149ba7d8fd3ba9a082760bc3d27a4d77d9dc917f00b5f8c5b95386f55889'
AND (
token = 'tTwV/JSg1NN0JNQTFlWMfPja0V9lENl1deKcoCmgYHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)