UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1vAxda0cZ5DuossDyXMvkROJSmm6zE1S15POdkjjYTY='
WHERE
key_id = '69d9886813be71e9b2776076f429e6c933d00c046374633de838e3d0a27c8b3b'
AND (
token = '1vAxda0cZ5DuossDyXMvkROJSmm6zE1S15POdkjjYTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)