UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1UdNntTEVoKILfhnwdAy1vC9/wSYw/ZkdMSTobeuiV8='
WHERE
key_id = '6b2a0677cb8cb290ab3cedb9f0170c87334ec634e870e8732a1bccae13ccce2f'
AND (
token = '1UdNntTEVoKILfhnwdAy1vC9/wSYw/ZkdMSTobeuiV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)