UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1RfjSMrnfn3bgogCRc+Lu/ANxWtKEiiMyNsjE/6fHF4='
WHERE
key_id = '0fd3918850f50cb4ea72ae905086f2c915c1f039c96d25f1cf0f0bcfac93871e'
AND (
token = '1RfjSMrnfn3bgogCRc+Lu/ANxWtKEiiMyNsjE/6fHF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)