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