UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vk+8tWNyBokZKBfLHzxlGUiPSCSVlL4I5UVd1QXb7iM='
WHERE
key_id = '43a6b2c2f7c20a1e3b147bec4ca23efdcc136ea196cff52d8c46e4a4a957fbf5'
AND (
token = 'Vk+8tWNyBokZKBfLHzxlGUiPSCSVlL4I5UVd1QXb7iM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)