UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQFluaza9CYeXWpDoA159dXwYEfzA6dJJrQ6Z/RoMtQ='
WHERE
key_id = '22150f4168ebbfe9615d9ef808485a7184b4a10faf791aedae7ab7e66dcf8ec3'
AND (
token = 'LQFluaza9CYeXWpDoA159dXwYEfzA6dJJrQ6Z/RoMtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)