UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uEO7MJzZve5FV2W5EsYobzx8RuKzFNcFlhLFZxbWvDk='
WHERE
key_id = '862c952be385c0c149dde0452fe4056f458a9f62d7ec2e321853dbdec4efae83'
AND (
token = 'uEO7MJzZve5FV2W5EsYobzx8RuKzFNcFlhLFZxbWvDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)