UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YnQN7rwBB9sa7MblEMCRkbj72DQkY+A4g1+TbcwQmHA='
WHERE
key_id = '686406777c2bb02dc42f45dbfe8f5b92ff2d941db93ef9121b237a2e82f971ba'
AND (
token = 'YnQN7rwBB9sa7MblEMCRkbj72DQkY+A4g1+TbcwQmHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)