UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/6vBfNoxy56ysyqeRwhGrL/5sirwZqIU2sY6sC/SsYM='
WHERE
key_id = '585efa16428f33e21fd2f9b6b1459cd6e12ab834693fc5773d248b1a3f23bc9c'
AND (
token = '/6vBfNoxy56ysyqeRwhGrL/5sirwZqIU2sY6sC/SsYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)