mysql 传入参数存储过程

DROP PROCEDURE IF EXISTS `sp_InsertCustomerOnline`;
CREATE PROCEDURE `sp_InsertCustomerOnline`(IN `in_cid` int,IN `in_pKey` varchar(20),in_serverkey varchar(20),IN `in_logintime` datetime,IN `in_ip` varchar(16),IN `in_token` varchar(36))
BEGIN
DECLARE tcount int default 0;
  select count(token) into tcount from ser_CustomerOnline where Token=in_token;
  if(tcount=0)THEN
     insert into ser_CustomerOnline(customerid,serverkey,product,LoginTime,RefreshTime,IP,Token)VALUES(in_cid,in_serverkey,in_pKey,in_logintime,in_logintime,in_ip,in_token);
  ELSE
     update ser_CustomerOnline set serverkey=in_serverkey, product =in_pKey,LoginTime =in_logintime,RefreshTime=in_logintime,Ip=in_ip where Token =in_token ;
  end if;
END