UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nh7ib8UNzOYjtl2p0avZgdPtt3n2pxkYQ7Ei1zungPc='
WHERE
key_id = '960d83573b9301b7437c53d1abc19811cf4336a324b75d3a1f06f82587e3971a'
AND (
token = 'nh7ib8UNzOYjtl2p0avZgdPtt3n2pxkYQ7Ei1zungPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)