UPDATE `verificaconta` as `verif`
INNER JOIN `sysusuarios` as `usuarios` ON `usuarios`.`cod` = `verif`.`cod`
  SET `verif`.`ativo` = '0', `usuarios`.`ativo` ='1'
  WHERE `verif`.`codvalidacao` = ?'

SET SQL_SAFE_UPDATES = 0;
UPDATE `verificaconta` as `verif`
INNER JOIN `sysusuarios` as `usuarios` ON `usuarios`.`cod` = `verif`.`cod`
  SET `verif`.`ativo` = '0', `usuarios`.`ativo` ='1'
  WHERE `verif`.`codvalidacao` = ?'
SET SQL_SAFE_UPDATES = 1;