UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'avKOdiu8huxZ07VwmhAxVG9dm6CYkQSOmK6FTdMr3RU='
WHERE
key_id = '9e8f1476ffde8f32210f17c30a41fa09c3264ac80a880c8fcb8ca7906488e06d'
AND (
token = 'avKOdiu8huxZ07VwmhAxVG9dm6CYkQSOmK6FTdMr3RU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)