UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4homYfOaQzh7s5lUcWIoQ3h7NP54DJj/n2RzdNW0ozM='
WHERE
key_id = '1c2b36dcedde62329b21c2bf5494fd2e4216521effde5c233352418bde464c78'
AND (
token = '4homYfOaQzh7s5lUcWIoQ3h7NP54DJj/n2RzdNW0ozM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)