UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXCMuImVOofmM9p+D97+mTDXHiDJ7rLLsXMeJNl2S5E='
WHERE
key_id = '8517a704c140481b1dc66c69146192dd6cd2c207a6313fa00ebc39e88ac0f117'
AND (
token = 'KXCMuImVOofmM9p+D97+mTDXHiDJ7rLLsXMeJNl2S5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)