mysql 防止一条记录被更新两次

var sql_getSys = "UPDATE template SET state = 1 WHERE id=? and state=0; ";
Me.db.query(sql_getSys, [taskid], function (err, result) {
if (err) {
return cbError(51001, Me.cb);
} else {
if (result.changedRows > 0) {
return ep.emit(‘searchUser’);
}else{
return Me.cb(-200,‘群发只能点一次’ , null);
}
}
})