UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZbhAUJ8T6O8ZMWd2qhF8LQsvS1wvkDui9XjXhFhIbPw='
WHERE
key_id = '3a61d8b670ad08fcf45d728812daa3fb179662dccd7deeb0d251cc3e873f135a'
AND (
token = 'ZbhAUJ8T6O8ZMWd2qhF8LQsvS1wvkDui9XjXhFhIbPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)