UPDATE <prefix>user
SET password = MD5(CONCAT(MD5('new-password'), salt))
WHERE userid = X
...with 'X' being your userid number and <prefix> being your table prefix.
-------------
for example:
UPDATE forums_user SET PASSWORD = MD5( CONCAT( MD5( 'jacklee' ) , salt ) ) WHERE userid =1