UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sW3qLRohpvv8+mmrsIMmV/1SF/UA52LvmCu3CKjSygU='
WHERE
key_id = '8e9372b486fb05b1be4a7d179c379c2b367dc043d4335c897fce6ce5dddf0d17'
AND (
token = 'sW3qLRohpvv8+mmrsIMmV/1SF/UA52LvmCu3CKjSygU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)