UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/cM0LJV857Wmj5oyqYVqIYzVpnA4VRbSvXAs/r4lDHM='
WHERE
key_id = '86f99a134e9a745298f9f61ea4b19f15bf8cd251d916e9c3dfcf6e4a295bf8d5'
AND (
token = '/cM0LJV857Wmj5oyqYVqIYzVpnA4VRbSvXAs/r4lDHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)