UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K84SFOsXu000BDIRYHUzRHYmL0WZzaUrpkC0uu0ZPOk='
WHERE
key_id = '6696df30a3ebbb6dcb06f2730ef37cf516be83a1c70ba86052f5f905e0498eed'
AND (
token = 'K84SFOsXu000BDIRYHUzRHYmL0WZzaUrpkC0uu0ZPOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)