UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RNUYSkyDQa3mheux51ykM6sCQm0zG2kFVwmT92LRcTo='
WHERE
key_id = '8ce00a77780f9f44b444fee919a552e21ecb27776180b6b0a07af8d049e2fa94'
AND (
token = 'RNUYSkyDQa3mheux51ykM6sCQm0zG2kFVwmT92LRcTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)