UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LuorGXsdZIFkf/txIxc7T6kSuy2VzVXp8Y03I54/njM='
WHERE
key_id = 'bad2b0b0f1b4ad78ff55fdf6dee491e1e404d123914abebc7a652728b29208ee'
AND (
token = 'LuorGXsdZIFkf/txIxc7T6kSuy2VzVXp8Y03I54/njM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)