UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0IizQyQBVMXieR6XXy5gwFy+OMQXXGK+U070pelF/LY='
WHERE
key_id = '1fca5fdb98e0e417c35fbf1308bb80a37b4f8f3f3996a6f80c86a992c46fd4f2'
AND (
token = '0IizQyQBVMXieR6XXy5gwFy+OMQXXGK+U070pelF/LY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)