UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQZNN0GA4GZX6IjUeiMtAx7NmnKAJcQZpRiGnKxedio='
WHERE
key_id = '52caac2254c15a3b78d55ad52099fb4d9df9de6d2ada29579d7784871be3f7a0'
AND (
token = 'tQZNN0GA4GZX6IjUeiMtAx7NmnKAJcQZpRiGnKxedio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)