UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/VV9NduuEWclm/dwew/lTkQXpt5Ua8/Jj4WZSNdhTus='
WHERE
key_id = 'c414040ce802d1170454a7ef95cfb99f2f1dd4dbe3b5c3338e3441de0da1986e'
AND (
token = '/VV9NduuEWclm/dwew/lTkQXpt5Ua8/Jj4WZSNdhTus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)