UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b7V/BEoHxtbv40ykfk+K4O+yCFAy8XFMWEszBygEWVs='
WHERE
key_id = 'd1f050598e03f79e8bf07c32519087f10e31faba6290a2b9c39bf96828611b15'
AND (
token = 'b7V/BEoHxtbv40ykfk+K4O+yCFAy8XFMWEszBygEWVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)