UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kabuft20VKagRjKYFIhvWmfavpGuwXwUI/f4vXuMWvI='
WHERE
key_id = 'e88795a2e5b449e0e6f8f2ce8c2fa07620869493957668098be22050d4da3e24'
AND (
token = 'kabuft20VKagRjKYFIhvWmfavpGuwXwUI/f4vXuMWvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)